package com.mac.cxcybackground.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mac.cxcybackground.bean.Awards;
import com.mac.cxcybackground.vo.AwardsVo;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface AwardsMapper extends BaseMapper<Awards> {
     @Select("select id,awards.sNo,sName,sGrade,sProfessional,`time`,activity,award from awards, students where students.sno=awards.sno;")
    List<AwardsVo> findAllList();
}
